package com.sanyog.util;


public interface DBStatement {

	//public final static String CREATE_USER = "CREATE TABLE postad_user ( UserName VARCHAR(256), Email VARCHAR(256),mobileNo VARCHAR(256),Password VARCHAR(256), state VARCHAR(256),CREATE_DATE VARCHAR(256))";
	public final static String CREATE_POST_AD = "CREATE TABLE postad_ad ( UserName VARCHAR(256), Email VARCHAR(256),mobileNo VARCHAR(256),Title VARCHAR(256) , Description VARCHAR(256),Category VARCHAR(256),state VARCHAR(256),Weblink VARCHAR(256) , POSTAD_DATE VARCHAR(256))";
	public final static String CREATE_POST_ADMIN = "CREATE TABLE postad_admin ( UserName VARCHAR(256), Password VARCHAR(256))";
	//public final static String USER_INSERT = "INSERT INTO postad_user(UserName,Email,mobileNo,Password,state) VALUES(?,?,?,?,?)";
	public final static String POST_AD_INSERT = "INSERT into postad_ad(UserName,Password) VALUES(?,?)";
	public final static String SELECT_USER = "SELECT * FROM postad_user";
	public final static String SELECT_POST_ALL = "SELECT * FROM postad_ad";
	public final static String POST_AD_CAT = "SELECT * FROM postad_user where category=?";
	public final static String POST_AD_SEARCH_STATE = "SELECT * FROM postad_user where state=?";
	//public final static String TEMP = "CREATE TABLE postad_user ( id INTEGER IDENTITY, UserName VARCHAR(256), Email VARCHAR(256),mobileNo VARCHAR(256),Password VARCHAR(256), state VARCHAR(256))";

    public final static String POST_AD_ADMIN_USER=" CREATE TABLE postad_admin (UserName VARCHAR(256), Password VARCHAR(256),SUPER_ADMIN VARCHAR(20))";

    public final static String CREATE_RATING_TABLE = "CREATE TABLE rating ( Name VARCHAR(256), Email VARCHAR(256), Rating VARCHAR(1))";
}
